|
| |
|
|
Proposal of Database for Pivní burza pub
Heneš, Radek ; Hrušková, Lenka (referee) ; Kříž, Jiří (advisor)
Restaurant and pub Pivní burza is first of its kind on Czech market. The Pub operates on the principle of exchange (organized market), where the price of beer is floating and with increasing demand for one product, price of the other products is changing in real time. Customer can monitor the price developments and realize an order on the touch panel, which is located on the restaurant tables. Thesis is focused on the analysis of the current status of the restaurant, own solution design and suggestions for future improvements.
|
|
|
Business Intelligence as Data Analysis Tool for Controlling the Company
Novák, Ondřej ; Hajn, Pavel (referee) ; Kříž, Jiří (advisor)
Designing and creating the finished OLAP solutions within Business Intelligence for an undertaking by the customer's requirements using standard technologies and practices that are designed for this purpose. This work describes the work of the design, creation and deployment of the finished project Business Intelligence solution that allows the customer to perform more accurate analysis of their own data in the context of controlling.
|
|
| |
|
| |
|
|
Association Rules Mining over Data Warehouses
Hlavička, Ladislav ; Chmelař, Petr (referee) ; Stryka, Lukáš (advisor)
This thesis deals with association rules mining over data warehouses. In the first part the reader will be familiarized with terms like knowledge discovery in databases and data mining. The following part of the work deals with data warehouses. Further the association analysis, the association rules, their types and mining possibilities are described. The architecture of Microsoft SQL Server and its tools for working with data warehouses are presented. The rest of the thesis includes description and analysis of the Star-miner algorithm, design, implementation and testing of the application.
|
|
|
Sequential Pattern Mining
Tisoň, Zdeněk ; Zendulka, Jaroslav (referee) ; Hlosta, Martin (advisor)
This master's thesis is focused on knowledge discovery from databases, especially on methods of mining sequential patterns. Individual methods of mining sequential patterns are described in detail. Further, this work deals with extending the platform Microsoft SQL Server Analysis Services of new mining algorithms. In the practical part of this thesis, plugins for mining sequential patterns are implemented into MS SQL Server. In the last part, these algorithms are compared on different data sets.
|
|
| |
|
|
Solution for Deviation Analysis of Cost in a Manufacturing Company
Dobeš, Radim ; Peterka, Miloslav (referee) ; Luhan, Jan (advisor)
At the very beginning of the diploma thesis, we introduce the reader to the issues of BI and controlling of manufacturing companies. Subsequently, we perform an analysis and evaluation of the current state of the selected manufacturing company in terms of variations in production. Then we use MSSQL server and SSAS to create a controlling model. The company will be able to unambiguously and quickly identify weaknesses in production and quickly eliminate them. Finally, we evaluate the real benefits of this project for the company.
|
|
|
Proposal of Database for Effective Functioning of a Guesthouse
Kornelly, Roman ; Luhan, Jan (referee) ; Kříž, Jiří (advisor)
This bachelor thesis is concerned with designing a database intended to streamline the activities taking place in the Rumburak s.r.o. guesthouse. The first part of the thesis presents the theoretical foundation required for tackling the problem. Following is an analysis of the processes involved in the current operations, pinpointing their problem points. The core part of the thesis focuses on the actual design comprised of a module for person management, booking and invoicing. The result of the work done on the thesis is a fully functional database that meets the requirements of the company.
|
guest ::
